Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 5706 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 579.5 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 12 |
|---|
recency is highly overall correlated with purchase_count | High correlation |
avg_purchase_interval is highly overall correlated with purchase_count | High correlation |
nunique_products is highly overall correlated with avg_basket_size and 2 other fields | High correlation |
avg_basket_size is highly overall correlated with nunique_products and 2 other fields | High correlation |
purchase_count is highly overall correlated with recency and 4 other fields | High correlation |
charge_back_count is highly overall correlated with purchase_count and 1 other fields | High correlation |
return_rate is highly overall correlated with purchase_count and 1 other fields | High correlation |
avg_order_value is highly overall correlated with nunique_products and 2 other fields | High correlation |
gross_revenue is highly overall correlated with nunique_products and 3 other fields | High correlation |
avg_unt_price is highly skewed (γ1 = 40.05551367) | Skewed |
avg_order_value is highly skewed (γ1 = 21.75818136) | Skewed |
gross_revenue is highly skewed (γ1 = 23.73500315) | Skewed |
customer_id has unique values | Unique |
charge_back_count has 4199 (73.6%) zeros | Zeros |
return_rate has 4199 (73.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-29 19:33:07.911097 |
|---|---|
| Analysis finished | 2023-05-29 19:33:31.906088 |
| Duration | 23.99 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 5706 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11208.74 |
| Minimum | -3710 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1371 |
| Negative (%) | 24.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | -3710 |
|---|---|
| 5-th percentile | -2747 |
| Q1 | 12415.5 |
| median | 14365.5 |
| Q3 | 16317.75 |
| 95-th percentile | 17892.75 |
| Maximum | 18287 |
| Range | 21997 |
| Interquartile range (IQR) | 3902.25 |
Descriptive statistics
| Standard deviation | 7446.2304 |
|---|---|
| Coefficient of variation (CV) | 0.66432358 |
| Kurtosis | -0.5736743 |
| Mean | 11208.74 |
| Median Absolute Deviation (MAD) | 1951.5 |
| Skewness | -1.0929403 |
| Sum | 63957071 |
| Variance | 55446347 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| -2087 | 1 | < 0.1% |
| 14053 | 1 | < 0.1% |
| 16009 | 1 | < 0.1% |
| 12922 | 1 | < 0.1% |
| -2098 | 1 | < 0.1% |
| 16589 | 1 | < 0.1% |
| 13730 | 1 | < 0.1% |
| 16866 | 1 | < 0.1% |
| -2096 | 1 | < 0.1% |
| Other values (5696) | 5696 |
| Value | Count | Frequency (%) |
| -3710 | 1 | |
| -3709 | 1 | |
| -3708 | 1 | |
| -3707 | 1 | |
| -3706 | 1 | |
| -3705 | 1 | |
| -3701 | 1 | |
| -3700 | 1 | |
| -3697 | 1 | |
| -3696 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18283 | 1 | |
| 18282 | 1 | |
| 18281 | 1 | |
| 18280 | 1 | |
| 18278 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18274 | 1 | |
| 18273 | 1 |
lifetime
Real number (ℝ)
| Distinct | 305 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 216.153 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 4 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 109 |
| median | 238 |
| Q3 | 318 |
| 95-th percentile | 369 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 209 |
Descriptive statistics
| Standard deviation | 116.57112 |
|---|---|
| Coefficient of variation (CV) | 0.53929913 |
| Kurtosis | -1.2334936 |
| Mean | 216.153 |
| Median Absolute Deviation (MAD) | 96 |
| Skewness | -0.29342833 |
| Sum | 1233369 |
| Variance | 13588.827 |
| Monotonicity | Decreasing |
| Value | Count | Frequency (%) |
| 373 | 101 | 1.8% |
| 372 | 98 | 1.7% |
| 366 | 88 | 1.5% |
| 368 | 78 | 1.4% |
| 365 | 76 | 1.3% |
| 369 | 70 | 1.2% |
| 358 | 66 | 1.2% |
| 367 | 61 | 1.1% |
| 371 | 57 | 1.0% |
| 359 | 46 | 0.8% |
| Other values (295) | 4965 |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.1% |
| 1 | 11 | |
| 2 | 7 | 0.1% |
| 3 | 13 | |
| 4 | 18 | |
| 5 | 9 | |
| 7 | 13 | |
| 8 | 6 | 0.1% |
| 9 | 14 | |
| 10 | 21 |
| Value | Count | Frequency (%) |
| 373 | 101 | |
| 372 | 98 | |
| 371 | 57 | |
| 369 | 70 | |
| 368 | 78 | |
| 367 | 61 | |
| 366 | 88 | |
| 365 | 76 | |
| 364 | 45 | |
| 362 | 32 | 0.6% |
recency
Real number (ℝ)
| Distinct | 304 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.90536 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 38 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 23 |
| median | 71 |
| Q3 | 199.75 |
| 95-th percentile | 338 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 176.75 |
Descriptive statistics
| Standard deviation | 111.57499 |
|---|---|
| Coefficient of variation (CV) | 0.9544044 |
| Kurtosis | -0.63999466 |
| Mean | 116.90536 |
| Median Absolute Deviation (MAD) | 61 |
| Skewness | 0.81457626 |
| Sum | 667062 |
| Variance | 12448.979 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110 | 1.9% |
| 4 | 105 | 1.8% |
| 3 | 98 | 1.7% |
| 2 | 92 | 1.6% |
| 10 | 86 | 1.5% |
| 8 | 82 | 1.4% |
| 9 | 79 | 1.4% |
| 17 | 79 | 1.4% |
| 7 | 78 | 1.4% |
| 15 | 67 | 1.2% |
| Other values (294) | 4830 |
| Value | Count | Frequency (%) |
| 0 | 38 | 0.7% |
| 1 | 110 | |
| 2 | 92 | |
| 3 | 98 | |
| 4 | 105 | |
| 5 | 52 | |
| 7 | 78 | |
| 8 | 82 | |
| 9 | 79 | |
| 10 | 86 |
| Value | Count | Frequency (%) |
| 373 | 23 | |
| 372 | 23 | |
| 371 | 17 | |
| 369 | 4 | 0.1% |
| 368 | 13 | |
| 367 | 16 | |
| 366 | 15 | |
| 365 | 19 | |
| 364 | 11 | |
| 362 | 7 | 0.1% |
avg_purchase_interval
Real number (ℝ)
| Distinct | 1242 |
|---|---|
| Distinct (%) | 21.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.389285 |
| Minimum | 0.66666667 |
|---|---|
| Maximum | 186.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0.66666667 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 12.372414 |
| Q3 | 53.107143 |
| 95-th percentile | 128 |
| Maximum | 186.5 |
| Range | 185.83333 |
| Interquartile range (IQR) | 52.107143 |
Descriptive statistics
| Standard deviation | 44.234909 |
|---|---|
| Coefficient of variation (CV) | 1.3248235 |
| Kurtosis | 1.760834 |
| Mean | 33.389285 |
| Median Absolute Deviation (MAD) | 11.372414 |
| Skewness | 1.5287103 |
| Sum | 190519.26 |
| Variance | 1956.7272 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2673 | |
| 62 | 15 | 0.3% |
| 30 | 15 | 0.3% |
| 92 | 14 | 0.2% |
| 186 | 14 | 0.2% |
| 53 | 13 | 0.2% |
| 16.5 | 12 | 0.2% |
| 26 | 12 | 0.2% |
| 90 | 11 | 0.2% |
| 39 | 11 | 0.2% |
| Other values (1232) | 2916 |
| Value | Count | Frequency (%) |
| 0.6666666667 | 1 | < 0.1% |
| 1 | 2673 | |
| 1.534979424 | 1 | < 0.1% |
| 1.718894009 | 1 | < 0.1% |
| 2.207100592 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 2.5 | 1 | < 0.1% |
| 2.96031746 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 3.127118644 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 186.5 | 11 | |
| 186 | 14 | |
| 185.5 | 5 | 0.1% |
| 184.5 | 11 | |
| 184 | 8 | |
| 183.5 | 4 | 0.1% |
| 183 | 7 | |
| 182.5 | 10 | |
| 182 | 4 | 0.1% |
| 181 | 2 | < 0.1% |
nunique_products
Real number (ℝ)
| Distinct | 439 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.617596 |
| Minimum | 1 |
|---|---|
| Maximum | 1786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 13 |
| median | 36 |
| Q3 | 84 |
| 95-th percentile | 241 |
| Maximum | 1786 |
| Range | 1785 |
| Interquartile range (IQR) | 71 |
Descriptive statistics
| Standard deviation | 101.64794 |
|---|---|
| Coefficient of variation (CV) | 1.4600897 |
| Kurtosis | 43.951941 |
| Mean | 69.617596 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 4.7072082 |
| Sum | 397238 |
| Variance | 10332.303 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 279 | 4.9% |
| 2 | 149 | 2.6% |
| 3 | 113 | 2.0% |
| 10 | 101 | 1.8% |
| 5 | 98 | 1.7% |
| 9 | 96 | 1.7% |
| 6 | 93 | 1.6% |
| 8 | 93 | 1.6% |
| 11 | 93 | 1.6% |
| 4 | 90 | 1.6% |
| Other values (429) | 4501 |
| Value | Count | Frequency (%) |
| 1 | 279 | |
| 2 | 149 | |
| 3 | 113 | |
| 4 | 90 | 1.6% |
| 5 | 98 | 1.7% |
| 6 | 93 | 1.6% |
| 7 | 90 | 1.6% |
| 8 | 93 | 1.6% |
| 9 | 96 | 1.7% |
| 10 | 101 | 1.8% |
| Value | Count | Frequency (%) |
| 1786 | 1 | |
| 1766 | 1 | |
| 1322 | 1 | |
| 1118 | 1 | |
| 1109 | 1 | |
| 884 | 1 | |
| 817 | 1 | |
| 748 | 1 | |
| 730 | 1 | |
| 720 | 1 |
avg_basket_size
Real number (ℝ)
| Distinct | 2490 |
|---|---|
| Distinct (%) | 43.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 224.98652 |
| Minimum | -140.5 |
|---|---|
| Maximum | 14149 |
| Zeros | 12 |
| Zeros (%) | 0.2% |
| Negative | 3 |
| Negative (%) | 0.1% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | -140.5 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 65.406061 |
| median | 133.5 |
| Q3 | 257 |
| 95-th percentile | 668.5 |
| Maximum | 14149 |
| Range | 14289.5 |
| Interquartile range (IQR) | 191.59394 |
Descriptive statistics
| Standard deviation | 419.32137 |
|---|---|
| Coefficient of variation (CV) | 1.8637622 |
| Kurtosis | 450.27512 |
| Mean | 224.98652 |
| Median Absolute Deviation (MAD) | 84.5 |
| Skewness | 16.009513 |
| Sum | 1283773.1 |
| Variance | 175830.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 114 | 2.0% |
| 2 | 70 | 1.2% |
| 3 | 52 | 0.9% |
| 4 | 49 | 0.9% |
| 5 | 35 | 0.6% |
| 6 | 29 | 0.5% |
| 12 | 27 | 0.5% |
| 72 | 24 | 0.4% |
| 7 | 21 | 0.4% |
| 120 | 20 | 0.4% |
| Other values (2480) | 5265 |
| Value | Count | Frequency (%) |
| -140.5 | 1 | < 0.1% |
| -101 | 1 | < 0.1% |
| -44 | 1 | < 0.1% |
| 0 | 12 | 0.2% |
| 0.25 | 1 | < 0.1% |
| 0.6666666667 | 1 | < 0.1% |
| 1 | 114 | |
| 2 | 70 | |
| 3 | 52 | |
| 3.333333333 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14149 | 1 | |
| 13956 | 1 | |
| 7824 | 1 | |
| 5963 | 1 | |
| 5197 | 1 | |
| 4300 | 1 | |
| 4280 | 1 | |
| 4136 | 1 | |
| 3206.083333 | 1 | |
| 3028 | 1 |
purchase_count
Real number (ℝ)
| Distinct | 63 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0553803 |
| Minimum | 1 |
|---|---|
| Maximum | 243 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 14 |
| Maximum | 243 |
| Range | 242 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 8.1309021 |
|---|---|
| Coefficient of variation (CV) | 2.0049666 |
| Kurtosis | 274.18899 |
| Mean | 4.0553803 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.593167 |
| Sum | 23140 |
| Variance | 66.111569 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2672 | |
| 2 | 812 | 14.2% |
| 3 | 490 | 8.6% |
| 4 | 381 | 6.7% |
| 5 | 283 | 5.0% |
| 6 | 195 | 3.4% |
| 7 | 152 | 2.7% |
| 8 | 117 | 2.1% |
| 9 | 80 | 1.4% |
| 10 | 73 | 1.3% |
| Other values (53) | 451 | 7.9% |
| Value | Count | Frequency (%) |
| 1 | 2672 | |
| 2 | 812 | 14.2% |
| 3 | 490 | 8.6% |
| 4 | 381 | 6.7% |
| 5 | 283 | 5.0% |
| 6 | 195 | 3.4% |
| 7 | 152 | 2.7% |
| 8 | 117 | 2.1% |
| 9 | 80 | 1.4% |
| 10 | 73 | 1.3% |
| Value | Count | Frequency (%) |
| 243 | 1 | |
| 217 | 1 | |
| 169 | 1 | |
| 126 | 1 | |
| 118 | 2 | |
| 88 | 1 | |
| 75 | 1 | |
| 73 | 1 | |
| 66 | 1 | |
| 65 | 1 |
charge_back_count
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.58762706 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 4199 |
| Zeros (%) | 73.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.7490544 |
|---|---|
| Coefficient of variation (CV) | 2.9764702 |
| Kurtosis | 190.73026 |
| Mean | 0.58762706 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.274232 |
| Sum | 3353 |
| Variance | 3.0591913 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4199 | |
| 1 | 852 | 14.9% |
| 2 | 289 | 5.1% |
| 3 | 140 | 2.5% |
| 4 | 92 | 1.6% |
| 5 | 37 | 0.6% |
| 6 | 32 | 0.6% |
| 7 | 21 | 0.4% |
| 9 | 8 | 0.1% |
| 10 | 5 | 0.1% |
| Other values (13) | 31 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 4199 | |
| 1 | 852 | 14.9% |
| 2 | 289 | 5.1% |
| 3 | 140 | 2.5% |
| 4 | 92 | 1.6% |
| 5 | 37 | 0.6% |
| 6 | 32 | 0.6% |
| 7 | 21 | 0.4% |
| 8 | 5 | 0.1% |
| 9 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 45 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 1 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 5 |
return_rate
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 143 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.076905605 |
| Minimum | 0 |
|---|---|
| Maximum | 0.75 |
| Zeros | 4199 |
| Zeros (%) | 73.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.090909091 |
| 95-th percentile | 0.5 |
| Maximum | 0.75 |
| Range | 0.75 |
| Interquartile range (IQR) | 0.090909091 |
Descriptive statistics
| Standard deviation | 0.14837871 |
|---|---|
| Coefficient of variation (CV) | 1.9293615 |
| Kurtosis | 2.5147132 |
| Mean | 0.076905605 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8858298 |
| Sum | 438.82338 |
| Variance | 0.022016242 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4199 | |
| 0.5 | 246 | 4.3% |
| 0.3333333333 | 212 | 3.7% |
| 0.25 | 165 | 2.9% |
| 0.2 | 139 | 2.4% |
| 0.1666666667 | 78 | 1.4% |
| 0.1428571429 | 61 | 1.1% |
| 0.4 | 55 | 1.0% |
| 0.125 | 46 | 0.8% |
| 0.2857142857 | 40 | 0.7% |
| Other values (133) | 465 | 8.1% |
| Value | Count | Frequency (%) |
| 0 | 4199 | |
| 0.01369863014 | 1 | < 0.1% |
| 0.02222222222 | 1 | < 0.1% |
| 0.02272727273 | 1 | < 0.1% |
| 0.02631578947 | 1 | < 0.1% |
| 0.02857142857 | 1 | < 0.1% |
| 0.0303030303 | 1 | < 0.1% |
| 0.03225806452 | 1 | < 0.1% |
| 0.03333333333 | 1 | < 0.1% |
| 0.03448275862 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.75 | 1 | < 0.1% |
| 0.7142857143 | 1 | < 0.1% |
| 0.6666666667 | 19 | 0.3% |
| 0.6 | 14 | 0.2% |
| 0.5714285714 | 5 | 0.1% |
| 0.5555555556 | 2 | < 0.1% |
| 0.5454545455 | 2 | < 0.1% |
| 0.5 | 246 | |
| 0.4736842105 | 1 | < 0.1% |
| 0.4615384615 | 4 | 0.1% |
avg_unt_price
Real number (ℝ)
| Distinct | 5276 |
|---|---|
| Distinct (%) | 92.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7139415 |
| Minimum | 0.06 |
|---|---|
| Maximum | 434.65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 1.2515888 |
| Q1 | 2.2175 |
| median | 3.0467987 |
| Q3 | 4.25 |
| 95-th percentile | 6.6969669 |
| Maximum | 434.65 |
| Range | 434.59 |
| Interquartile range (IQR) | 2.0325 |
Descriptive statistics
| Standard deviation | 7.8417661 |
|---|---|
| Coefficient of variation (CV) | 2.1114404 |
| Kurtosis | 1956.3654 |
| Mean | 3.7139415 |
| Median Absolute Deviation (MAD) | 0.95800549 |
| Skewness | 40.055514 |
| Sum | 21191.75 |
| Variance | 61.493296 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.25 | 26 | 0.5% |
| 4.95 | 20 | 0.4% |
| 0.85 | 18 | 0.3% |
| 3.75 | 16 | 0.3% |
| 2.95 | 15 | 0.3% |
| 1.65 | 14 | 0.2% |
| 0.42 | 13 | 0.2% |
| 2.08 | 13 | 0.2% |
| 12.75 | 12 | 0.2% |
| 2.55 | 12 | 0.2% |
| Other values (5266) | 5547 |
| Value | Count | Frequency (%) |
| 0.06 | 1 | |
| 0.1225 | 1 | |
| 0.17 | 2 | |
| 0.2327777778 | 1 | |
| 0.29 | 2 | |
| 0.32 | 1 | |
| 0.33 | 1 | |
| 0.355 | 2 | |
| 0.358 | 1 | |
| 0.3666666667 | 1 |
| Value | Count | Frequency (%) |
| 434.65 | 1 | |
| 295 | 1 | |
| 125 | 1 | |
| 110 | 2 | |
| 74.975 | 1 | |
| 66.475 | 1 | |
| 59.73333333 | 1 | |
| 54.3 | 1 | |
| 51.71 | 1 | |
| 39.95 | 1 |
avg_order_value
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5467 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 511.8143 |
| Minimum | -398.43 |
|---|---|
| Maximum | 52940.94 |
| Zeros | 5 |
| Zeros (%) | 0.1% |
| Negative | 8 |
| Negative (%) | 0.1% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | -398.43 |
|---|---|
| 5-th percentile | 12.4125 |
| Q1 | 140.35411 |
| median | 248.225 |
| Q3 | 433.735 |
| 95-th percentile | 1774.885 |
| Maximum | 52940.94 |
| Range | 53339.37 |
| Interquartile range (IQR) | 293.38089 |
Descriptive statistics
| Standard deviation | 1354.2907 |
|---|---|
| Coefficient of variation (CV) | 2.6460587 |
| Kurtosis | 746.59792 |
| Mean | 511.8143 |
| Median Absolute Deviation (MAD) | 131.63667 |
| Skewness | 21.758181 |
| Sum | 2920412.4 |
| Variance | 1834103.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.95 | 9 | 0.2% |
| 1.25 | 8 | 0.1% |
| 2.95 | 8 | 0.1% |
| 3.75 | 8 | 0.1% |
| 4.95 | 8 | 0.1% |
| 1.65 | 7 | 0.1% |
| 12.75 | 7 | 0.1% |
| 5.95 | 6 | 0.1% |
| 7.5 | 6 | 0.1% |
| 4.25 | 6 | 0.1% |
| Other values (5457) | 5633 |
| Value | Count | Frequency (%) |
| -398.43 | 1 | < 0.1% |
| -47.16 | 1 | < 0.1% |
| -31.97666667 | 1 | < 0.1% |
| -1.136868377 × 10-13 | 1 | < 0.1% |
| -5.684341886 × 10-14 | 1 | < 0.1% |
| -2.842170943 × 10-14 | 1 | < 0.1% |
| -1.421085472 × 10-14 | 2 | < 0.1% |
| 0 | 5 | |
| 2.842170943 × 10-14 | 1 | < 0.1% |
| 2.273736754 × 10-13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 52940.94 | 1 | |
| 50653.91 | 1 | |
| 21389.6 | 1 | |
| 18745.86 | 1 | |
| 14855.53 | 1 | |
| 12681.58 | 1 | |
| 12633.67 | 1 | |
| 12172.09 | 1 | |
| 11540.34 | 1 | |
| 10661.69 | 1 |
gross_revenue
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5465 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1718.8394 |
| Minimum | -796.86 |
|---|---|
| Maximum | 278778.02 |
| Zeros | 5 |
| Zeros (%) | 0.1% |
| Negative | 8 |
| Negative (%) | 0.1% |
| Memory size | 89.2 KiB |
Quantile statistics
| Minimum | -796.86 |
|---|---|
| 5-th percentile | 12.46 |
| Q1 | 230.2875 |
| median | 603.17 |
| Q3 | 1544.6075 |
| 95-th percentile | 5188.815 |
| Maximum | 278778.02 |
| Range | 279574.88 |
| Interquartile range (IQR) | 1314.32 |
Descriptive statistics
| Standard deviation | 7358.9531 |
|---|---|
| Coefficient of variation (CV) | 4.28135 |
| Kurtosis | 741.04642 |
| Mean | 1718.8394 |
| Median Absolute Deviation (MAD) | 474.185 |
| Skewness | 23.735003 |
| Sum | 9807697.7 |
| Variance | 54154191 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.95 | 9 | 0.2% |
| 4.95 | 8 | 0.1% |
| 1.25 | 8 | 0.1% |
| 2.95 | 8 | 0.1% |
| 1.65 | 7 | 0.1% |
| 12.75 | 7 | 0.1% |
| 3.75 | 7 | 0.1% |
| 4.25 | 6 | 0.1% |
| 7.5 | 6 | 0.1% |
| 5.95 | 6 | 0.1% |
| Other values (5455) | 5634 |
| Value | Count | Frequency (%) |
| -796.86 | 1 | < 0.1% |
| -141.48 | 1 | < 0.1% |
| -95.93 | 1 | < 0.1% |
| -2.273736754 × 10-13 | 1 | < 0.1% |
| -1.136868377 × 10-13 | 1 | < 0.1% |
| -5.684341886 × 10-14 | 1 | < 0.1% |
| -2.842170943 × 10-14 | 2 | < 0.1% |
| 0 | 5 | |
| 5.684341886 × 10-14 | 1 | < 0.1% |
| 4.547473509 × 10-13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278778.02 | 1 | |
| 259657.3 | 1 | |
| 189735.53 | 1 | |
| 133007.13 | 1 | |
| 123638.18 | 1 | |
| 114505.32 | 1 | |
| 88138.2 | 1 | |
| 65920.12 | 1 | |
| 62924.1 | 1 | |
| 59419.34 | 1 |
| customer_id | lifetime | recency | avg_purchase_interval | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | 0.142 | -0.236 | 0.396 | 0.007 | 0.025 | 0.398 | 0.219 | 0.214 | -0.233 | -0.095 | 0.092 |
| lifetime | 0.142 | 1.000 | 0.232 | 0.393 | 0.196 | -0.057 | 0.436 | 0.289 | 0.233 | 0.035 | -0.022 | 0.282 |
| recency | -0.236 | 0.232 | 1.000 | -0.299 | -0.326 | -0.179 | -0.575 | -0.329 | -0.269 | 0.203 | -0.067 | -0.425 |
| avg_purchase_interval | 0.396 | 0.393 | -0.299 | 1.000 | 0.200 | 0.036 | 0.733 | 0.365 | 0.398 | -0.149 | -0.054 | 0.332 |
| nunique_products | 0.007 | 0.196 | -0.326 | 0.200 | 1.000 | 0.607 | 0.430 | 0.279 | 0.218 | 0.064 | 0.619 | 0.799 |
| avg_basket_size | 0.025 | -0.057 | -0.179 | 0.036 | 0.607 | 1.000 | 0.088 | -0.008 | -0.035 | -0.168 | 0.858 | 0.692 |
| purchase_count | 0.398 | 0.436 | -0.575 | 0.733 | 0.430 | 0.088 | 1.000 | 0.688 | 0.631 | -0.160 | -0.001 | 0.625 |
| charge_back_count | 0.219 | 0.289 | -0.329 | 0.365 | 0.279 | -0.008 | 0.688 | 1.000 | 0.977 | -0.050 | -0.062 | 0.415 |
| return_rate | 0.214 | 0.233 | -0.269 | 0.398 | 0.218 | -0.035 | 0.631 | 0.977 | 1.000 | -0.044 | -0.091 | 0.340 |
| avg_unt_price | -0.233 | 0.035 | 0.203 | -0.149 | 0.064 | -0.168 | -0.160 | -0.050 | -0.044 | 1.000 | 0.197 | 0.079 |
| avg_order_value | -0.095 | -0.022 | -0.067 | -0.054 | 0.619 | 0.858 | -0.001 | -0.062 | -0.091 | 0.197 | 1.000 | 0.723 |
| gross_revenue | 0.092 | 0.282 | -0.425 | 0.332 | 0.799 | 0.692 | 0.625 | 0.415 | 0.340 | 0.079 | 0.723 | 1.000 |
| customer_id | lifetime | recency | avg_purchase_interval | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850.0 | 373.0 | 372.0 | 10.657143 | 21.0 | 48.371429 | 35 | 1.0 | 0.028571 | 3.960370 | 151.103714 | 5288.63 |
| 1 | 13047.0 | 373.0 | 56.0 | 23.312500 | 105.0 | 84.687500 | 16 | 7.0 | 0.437500 | 3.926082 | 193.068750 | 3089.10 |
| 2 | 12583.0 | 373.0 | 2.0 | 21.941176 | 114.0 | 292.823529 | 17 | 2.0 | 0.117647 | 2.140474 | 389.961176 | 6629.34 |
| 3 | 13748.0 | 373.0 | 95.0 | 74.600000 | 24.0 | 87.800000 | 5 | 0.0 | 0.000000 | 3.996429 | 189.650000 | 948.25 |
| 4 | 15100.0 | 373.0 | 333.0 | 62.166667 | 1.0 | 9.666667 | 6 | 3.0 | 0.500000 | 10.950000 | 105.850000 | 635.10 |
| 5 | 15291.0 | 373.0 | 25.0 | 19.631579 | 61.0 | 109.105263 | 19 | 5.0 | 0.263158 | 4.702255 | 239.553158 | 4551.51 |
| 6 | 14688.0 | 373.0 | 7.0 | 13.814815 | 148.0 | 119.333333 | 27 | 6.0 | 0.222222 | 2.131040 | 189.162222 | 5107.38 |
| 7 | 17809.0 | 373.0 | 16.0 | 26.642857 | 46.0 | 144.000000 | 14 | 2.0 | 0.142857 | 2.905738 | 381.775000 | 5344.85 |
| 8 | 15311.0 | 373.0 | 0.0 | 3.161017 | 567.0 | 319.661017 | 118 | 27.0 | 0.228814 | 2.506036 | 503.553729 | 59419.34 |
| 9 | 16098.0 | 373.0 | 87.0 | 53.285714 | 34.0 | 87.571429 | 7 | 0.0 | 0.000000 | 4.424627 | 286.518571 | 2005.63 |
| customer_id | lifetime | recency | avg_purchase_interval | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5696 | -3701.0 | 1.0 | 1.0 | 1.0 | 55.0 | 1074.0 | 1 | 0.0 | 0.0 | 7.254516 | 4839.42 | 4839.42 |
| 5697 | 13298.0 | 1.0 | 1.0 | 1.0 | 2.0 | 96.0 | 1 | 0.0 | 0.0 | 3.750000 | 360.00 | 360.00 |
| 5698 | 14569.0 | 1.0 | 1.0 | 1.0 | 10.0 | 79.0 | 1 | 0.0 | 0.0 | 3.920000 | 227.39 | 227.39 |
| 5699 | -3705.0 | 1.0 | 1.0 | 1.0 | 7.0 | 14.0 | 1 | 0.0 | 0.0 | 1.278571 | 17.90 | 17.90 |
| 5700 | -3706.0 | 1.0 | 1.0 | 1.0 | 2.0 | 2.0 | 1 | 0.0 | 0.0 | 1.675000 | 3.35 | 3.35 |
| 5701 | -3707.0 | 1.0 | 1.0 | 1.0 | 634.0 | 1747.0 | 1 | 0.0 | 0.0 | 4.320946 | 5699.00 | 5699.00 |
| 5702 | -3708.0 | 0.0 | 0.0 | 1.0 | 730.0 | 2010.0 | 1 | 0.0 | 0.0 | 4.175904 | 6756.06 | 6756.06 |
| 5703 | -3709.0 | 0.0 | 0.0 | 1.0 | 56.0 | 654.0 | 1 | 0.0 | 0.0 | 6.269661 | 3217.20 | 3217.20 |
| 5704 | -3710.0 | 0.0 | 0.0 | 1.0 | 217.0 | 731.0 | 1 | 0.0 | 0.0 | 6.364378 | 3950.72 | 3950.72 |
| 5705 | 12713.0 | 0.0 | 0.0 | 1.0 | 37.0 | 505.0 | 1 | 0.0 | 0.0 | 2.084595 | 794.55 | 794.55 |